/*
 Navicat Premium Data Transfer

 Source Server         : localhost
 Source Server Type    : PostgreSQL
 Source Server Version : 120005
 Source Host           : localhost:5432
 Source Catalog        : im
 Source Schema         : public

 Target Server Type    : PostgreSQL
 Target Server Version : 120005
 File Encoding         : 65001

 Date: 01/02/2021 11:40:14
*/


-- ----------------------------
-- Table structure for account
-- ----------------------------
DROP TABLE IF EXISTS "public"."account";
CREATE TABLE "public"."account" (
  "id" int8 NOT NULL DEFAULT nextval('account_id_seq'::regclass),
  "account" varchar(255) COLLATE "pg_catalog"."default" NOT NULL,
  "password" varchar(255) COLLATE "pg_catalog"."default" NOT NULL,
  "create_time" timestamp(6) NOT NULL,
  "salt" varchar(255) COLLATE "pg_catalog"."default" NOT NULL
)
;
ALTER TABLE "public"."account" OWNER TO "postgres";
COMMENT ON COLUMN "public"."account"."account" IS '账户';
COMMENT ON COLUMN "public"."account"."password" IS '密码';
COMMENT ON COLUMN "public"."account"."create_time" IS '创建时间';
COMMENT ON COLUMN "public"."account"."salt" IS '盐';

-- ----------------------------
-- Records of account
-- ----------------------------
BEGIN;
INSERT INTO "public"."account" VALUES (1, 'test', 'a94a8fe5ccb19ba61c4c0873d391e987982fbbd3', '2021-01-22 17:44:08', '1');
INSERT INTO "public"."account" VALUES (3, 'xiaoming', 'a1221c1ba6f59571346ce1c94abd7725961e3d2d', '2021-01-25 17:16:43', '1');
INSERT INTO "public"."account" VALUES (4, 'xiaohei', 'b2c5dd491299cecab461b4cc94f7f8276879537d', '2021-01-13 17:17:03', '1');
COMMIT;

-- ----------------------------
-- Primary Key structure for table account
-- ----------------------------
ALTER TABLE "public"."account" ADD CONSTRAINT "account_pkey" PRIMARY KEY ("id");
